Skip Headers

Oracle® Database Globalization Support Guide 10g Release 2 (10.2) Part Number B14225-02 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J L M N O P Q R S T U V W X

## Symbols

  $ORACLE_HOME/nls/data directory, 1.1.1
  $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat time zone file, 4.6
  $ORACLE_HOME/oracore/zoneinfo/timezone.dat time zone file, 4.6

## Numerics

  7-bit encoding schemes, 2.1.4.1, 2.1.4.1
  8-bit encoding schemes, 2.1.4.1, 2.1.4.1

## A

  abbreviations
    languages, A.1
  abstract datatype
    creating as NCHAR, 2.3.9
  accent, 5.5
  accent-insensitive linguistic sort, 5.5
  ADCS script
    migrating character sets in Real Application Clusters, 11.2.2.1
  ADD_MONTHS SQL function, 4.4
  ADO interface and Unicode, 7.6.6
  AL16UTF16 character set, 6.2.3, A.4.5
  AL24UTFFSS character set, 6.2.3
  AL32UTF8 character set, 6.2.3, 6.3.1, A.4.5
  ALTER SESSION statement
    SET NLS_CURRENCY clause, 3.8.2, 3.8.3
    SET NLS_LANGUAGE clause, 3.4.2.1
    SET NLS_NUMERIC_CHARACTERS clause, 3.7.2
    SET NLS_TERRITORY clause, 3.4.2.1
  ALTER TABLE MODIFY statement
    migrating from CHAR to NCHAR, 11.3.3, 11.3.3.1
  analyse_histgrm.sql script, 12.8
  analyse_rule.sql script, 12.8
  analyse_source.sql script, 12.8
  application-locales, 8.8.3
  Arial Unicode MS font, 13.1.1.1
  array parameter
    Database Character Set Scanner, 12.5
  ASCII encoding, 2.1.3.1
  AT LOCAL clause, 4.10
  AT TIME ZONE clause, 4.10

## B

  base letters, 5.3.3.1, 5.4.1
  BFILE data
    loading into LOBs, 9.3.4
  binary sorts, 5.2
    case-insensitive and accent-insensitive, 5.5.2
    example, 5.5.3
  binding and defining CLOB and NCLOB data in OCI, 7.3.7
  binding and defining SQL CHAR datatypes in OCI, 7.3.4
  binding and defining SQL NCHAR datatypes in OCI, 7.3.5
  BLANK_TRIMMING parameter, 11.1.1.1
  BLOBs
    creating indexes, 6.5.4.3
  boundaries parameter
    Database Character Set Scanner, 12.5
  byte semantics, 2.2, 3.11.1

## C

  C number format mask, 3.8.3
  Calendar Utility, 13.3.2
  calendars
    customizing, 13.3.2
    parameter, 3.6
    supported, A.7
  canonical equivalence, 5.3.2, 5.4.6
  capture parameter
    Database Character Set Scanner, 12.5
  case, 5.1
  case-insensitive linguistic sort, 5.5
  CESU-8 compliance, A.4.5
  CHAR columns
    migrating to NCHAR columns, 11.3.3
  character data
    converting with CONVERT SQL function, 9.2.1
  character data conversion
    database character set, 11.2
  character data scanning
    before character set migration, 11.2
  character rearrangement, 5.4.8
  character repertoire, 2.1.1
  character semantics, 2.2, 3.11.1
  character set
    conversion, 13.5.2
    data loss
      during conversion, 2.3.3
    detecting with Globalization Development Kit, 8.7.6
    national, 7.2.1.2
  character set conversion
    between OCI client and database server, 7.3.2
    parameters, 3.10
  character set definition
    customizing, 13.5.6
    guidelines for editing files, 13.5.5
    naming files, 13.5.5
  character set migration
    CSALTER script, 11.2.2
    identifying character data conversion problems, 11.2
    postmigration tasks, 11.4
    scanning character data, 11.2
  character sets
    AL16UTF16, 6.2.3
    AL24UTFFSS, 6.2.3
    AL32UTF8, 6.2.3
    Asian, A.4.1, A.4.1, A.4.1
    changing after database creation, 2.4
    choosing, 11.1
    choosing a character set for a Unicode database, 6.3.4
    choosing a national character set, 6.3.4
    conversion, 2.3.3, 2.5.1, 9.2.1
    conversion using OCI, 10.7
    customizing, 13.5
    data loss, 11.1.2.1
    encoding, 2.1
    European, A.4.2, A.4.2
    ISO 8859 series, 2.1.3.1
    Middle Eastern, A.4.4
    migrating and the data dictionary, 12.8
    migration, 11.1, 11.1.1
    naming, 2.1.5
    national, 6.3.2, 7.2.1.1
    restrictions on character sets used to express names, 2.3.5.1
    supersets and subsets, A.4.7
    supported, A.4
    supporting different character repertoires, 2.1.3
    universal, A.4.5
    UTFE, 6.2.3
  character snational, 2.3.8
  character type conversion
    error reporting, 3.10.1
  characters
    available in all Oracle database character sets, 2.1.3
    context-sensitive, 5.4.5
    contracting, 5.4.3
    user-defined, 13.5.1
  choosing a character set, 11.1
  choosing between a Unicode database and Unicode datatypes, 6.3.3
  client operating system
    character set compatibility with applications, 2.3.2
  CLOB and NCLOB data
    binding and defining in OCI, 7.3.7
  CLOBs
    creating indexes, 6.5.4.2
  code chart
    displaying and printing, 13.4
  code point, 2.1.1
  collation
    customizing, 13.6
  column parameter
    Database Character Set Scanner, 12.5
  compatibility
    client operating system and application character sets, 2.3.2
  composed characters, 5.4.3
  context-sensitive characters, 5.4.5
  contracting characters, 5.4.3
  contracting letters, 5.4.10
  control characters, encoding, 2.1.2.3
  conversion
    between character set ID number and character set name, 9.2.4
  CONVERT SQL function, 9.2.1
    character sets, A.4.6
  convert time zones, 4.10
  convertible data
    data dictionary, 12.8
  converting character data
    CONVERT SQL function, 9.2.1
  converting character data between character sets, 9.2.1
  Coordinated Universal Time, 4.2.1.3, 4.2.1.4
  creating a database with Unicode datatypes, 6.3.2
  creating a Unicode database, 6.3.1
  CSALTER script, 11.2.2, 11.2.2.1
    checking phase, 12.10.1
    running, 12.10
    updating phase, 12.10.2
  CSM$COLUMNS table, 12.9.1.2
  CSM$ERRORS table, 12.9.1.3
  CSM$TABLES table, 12.9.1.1
  CSMIG user, 12.4.2
  csminst.sql script
    running, 12.4.2
  CSMV$COLUMNS view, 12.11.1
  CSMV$CONSTRAINTS view, 12.11.2
  CSMV$ERROR view, 12.11.3
  CSMV$INDEXES view, 12.11.4
  CSMV$TABLES view, 12.11.5
  currencies
    formats, 3.8.1
  CURRENT_DATE SQL function, 4.4
  CURRENT_TIMESTAMP SQL function, 4.4
  customizing time zone data, 13.3.1

## D

  data conversion
    in Pro*C/C++, 7.4.1
    OCI driver, 7.5.5.1
    ODBC and OLE DB drivers, 7.6.3
    thin driver, 7.5.5.2
    Unicode Java strings, 7.5.5
  data dictionary
    changing character sets, 12.8
    convertible or lossy data, 12.8
  data dictionary views
    NLS_DATABASE_PARAMETERS, 3.3.1
    NLS_INSTANCE_PARAMETERS, 3.3.1
    NLS_SESSION_PARAMETER, 3.3.1
  data expansion
    during character set migration, 11.1.1
    during data conversion, 7.3.2.3
  data inconsistencies causing data loss, 11.1.2.2
  data loss
    caused by data inconsistencies, 11.1.2.2
    during character set conversion, 2.3.3
    during character set migration, 11.1.2.1
    during datatype conversion
      exceptions, 7.2.3
    during OCI Unicode character set conversion, 7.3.2.1
    from mixed character sets, 11.1.2.2
  data truncation, 11.1.1
    restrictions, 11.1.1.1
  database character set
    character data conversion, 11.2
    choosing, 2.3
    compatibility between client operating system and applications, 2.3.2
    performance, 2.3.4
  Database Character Set Scanner, 12.5
    analyse_histgrm.sql script, 12.8
    analyse_rule.sql script, 12.8
    analyse_source.sql script, 12.8
    array parameter, 12.5
    boundaries parameter, 12.5
    capture parameter, 12.5
    column parameter, 12.5
    CSM$COLUMNS table, 12.9.1.2
    CSM$ERRORS table, 12.9.1.3
    CSM$TABLES table, 12.9.1.1
    CSMV$COLUMNS view, 12.11.1
    CSMV$CONSTRAINTS view, 12.11.2
    CSMV$ERROR view, 12.11.3
    CSMV$INDEXES view, 12.11.4
    CSMV$TABLES view, 12.11.5
    Database Scan Summary Report, 12.7.1
    error messages, 12.12
    exclude parameter, 12.5
    feedback parameter, 12.5
    fromnchar parameter, 12.5
    full parameter, 12.5
    help parameter, 12.5
    Individual Exception Report, 12.7.2
    invoking, 12.4.3
    lastrpt parameter, 12.5, 12.5
    maxblocks parameter, 12.5
    online help, 12.4.5
    performance, 12.9.2
    preserve parameter, 12.5
    query parameter, 12.5
    restrictions, 12.9.3
    scan modes, 12.3
    suppress parameter, 12.5
    table parameter, 12.5
    tochar parameter, 12.5
    user parameter, 12.5
    userid parameter, 12.5
    utility, 12.2
    views, 12.11
  Database Scan Summary Report, 12.7.1
  database schemas
    designing for multiple languages, 6.5
  database time zone, 4.8
  datatype conversion
    data loss and exceptions, 7.2.3
    implicit, 7.2.4
    SQL functions, 7.2.5
  datatypes
    abstract, 2.3.9
    DATE, 4.2.1.1
    datetime, 4.2
    inserting values into datetime datatypes, 4.2.1.5
    inserting values into interval datatypes, 4.2.2.3
    interval, 4.2, 4.2.2
    INTERVAL DAY TO SECOND, 4.2.2.2
    INTERVAL YEAR TO MONTH, 4.2.2.1
    supported, 2.3.9
    TIMESTAMP, 4.2.1.2
    TIMESTAMP WITH LOCAL TIME ZONE, 4.2.1.4
    TIMESTAMP WITH TIME ZONE, 4.2.1.3
  date and time parameters, 3.5
  DATE datatype, 4.2.1.1
  date formats, 3.5.1, 3.5.1.1, 9.3.1
    and partition bound expressions, 3.5.1.1
  dates
    ISO standard, 3.6.1.2, 9.3.2
    NLS_DATE_LANGUAGE parameter, 3.5.1.2
  datetime datatypes, 4.2
    inserting values, 4.2.1.5
  datetime format parameters, 4.5.1
  Daylight Saving Time
    Oracle support, 4.11
  daylight saving time session parameter, 4.5.3
  days
    format element, 3.5.1.2
    language of names, 3.5.1.2
  DB_TZ database time zone, 4.9
  DBMS_LOB PL/SQL package, 9.3.4
  DBMS_LOB.LOADBLOBFROMFILE procedure, 9.3.4
  DBMS_LOB.LOADCLOBFROMFILE procedure, 9.3.4
  DBMS_REDEFINITION.CAN_REDEF_TABLE procedure, 11.3.3.2
  DBTIMEZONE SQL function, 4.4
  dest_char_set parameter, A.4.6
  detecting language and character sets
    Globalization Development Kit, 8.7.6
  detection
    supported languages and character sets, A.5
  diacritic, 5.1
  dynamic performance views
    V$NLS_PARAMETERS, 3.3.2
    V$NLS_VALID_VALUES, 3.3.2

## E

  encoding
    control characters, 2.1.2.3
    ideographic writing systems, 2.1.2.2
    numbers, 2.1.2.3
    phonetic writing systems, 2.1.2.1
    punctuation, 2.1.2.3
    symbols, 2.1.2.3
  encoding schemes
    7-bit, 2.1.4.1, 2.1.4.1
    8-bit, 2.1.4.1, 2.1.4.1
    fixed-width, 2.1.4.2
    multibyte, 2.1.4.2
    shift-sensitive variable-width, 2.1.4.2
    shift-sensitive variable-width multibyte, 2.1.4.2
    single-byte, 2.1.4.1
    variable-width, 2.1.4.2
  environment variables
    ORA_SDTZ, 4.5.2, 4.9
    ORA_TZFILE, 4.5.2
  error messages
    languages, A.2
    translation, A.2
  ERROR_ON_OVERLAP_TIME session parameter, 4.5.3
  euro
    Oracle support, 3.8.5
  exclude parameter
    Database Character Set Scanner, 12.5
  expanding characters, 5.4.9
    characters
      expanding, 5.4.4
  EXTRACT (datetime) SQL function, 4.4

## F

  feedback parameter
    Database Character Set Scanner, 12.5
  fixed-width multibyte encoding schemes, 2.1.4.2
  fonts
    Unicode, 13.1.1
    Unicode for UNIX, 13.1.1.2
    Unicode for Windows, 13.1.1.1
  format elements, 9.3.3
    C, 9.3.3
    D, 9.3.3
    day, 3.5.1.2
    G, 9.3.3
    IW, 9.3.2
    IY, 9.3.2
    L, 9.3.3
    month, 3.5.1.2
    RM, 9.3.1
    RN, 9.3.3
  format masks, 3.7.2, 9.3.1
  formats
    currency, 3.8.1
    date, 3.5.1.1, 4.5.1
    numeric, 3.7.1
    time, 3.5.2
  FROM_TZ SQL function, 4.4
  fromchar parameter, 12.5
    Database Character Set Scanner, 12.5
  fromnchar parameter
    Database Character Set Scanner, 12.5
  full parameter
    Database Character Set Scanner, 12.5

## G

  GDK
    application configuration file, 8.6.1
  GDK application configuration file, 8.8
    example, 8.8.8
  GDK application framework for J2EE, 8.6, 8.6
  GDK components, 8.4
  GDK error messages, 8.11
  GDK Java API, 8.7
  GDK Java supplied packages and classes, 8.9
  GDK Localizer object, 8.6.4
  gdkapp.xml application configuration file, 8.8
  gdkapp.xml GDK application configuration file, 8.6.1
  getString() method, 7.5.6.1
  getStringWithReplacement() method, 7.5.6.1
  Globalization Development Kit, 8.1
    application configuration file, 8.8
    character set conversion, 8.7.3
    components, 8.4
    defining supported application locales, 8.6.5
    e-mail programs, 8.7.8
    error messages, 8.11
    framework, 8.6
    integrating locale sources, 8.6.2
    Java API, 8.7
    Java supplied packages and classes, 8.9
    locale detection, 8.6.3
    Localizer object, 8.6.4
    managing localized content in static files, 8.6.7.2
    managing strings in JSPs and Java servlets, 8.6.7.1
    non_ASCII input and output in an HTML page, 8.6.6
    Oracle binary and linguistic sorts, 8.7.5
    Oracle date, number, and monetary formats, 8.7.4
    Oracle language and character set detection, 8.7.6
    Oracle locale information, 8.7.1
    Oracle locale mapping, 8.7.2
    Oracle translated locale and time zone names, 8.7.7
    supported locale resources, 8.6.2
  globalization features, 1.2
  globalization support
    architecture, 1.1
  Greenwich Mean Time, 4.2.1.3, 4.2.1.4
  guessing the language or character set, 12.1

## H

  help parameter
    Database Character Set Scanner, 12.5

## I

  IANA character sets
    mapping with ISO locales, 8.6.6
  ideographic writing systems, encoding, 2.1.2.2
  ignorable characters, 5.4.2
  implicit datatype conversion, 7.2.4
  indexes
    creating for documents stored as CLOBs, 6.5.4.2
    creating for multilingual document search, 6.5.4
    creating indexes for documents stored as BLOBs, 6.5.4.3
    partitioned, 9.2.5.3
  Individual Exception Report, 12.7.2
  initialization parameters
    NLS_DATE_FORMAT, 4.5.1
    NLS_TIMESTAMP_FORMAT, 4.5.1
    NLS_TIMESTAMP_TZ_FORMAT, 4.5.1
  INSTR SQL functions, 7.2.6, 9.2.2, 9.2.2
  Internet application
    locale
      determination, 8.3.1
    monolingual, 8.2, 8.2.1
    multilingual, 8.2, 8.2.2
  interval datatypes, 4.2, 4.2.2
    inserting values, 4.2.2.3
  INTERVAL DAY TO SECOND datatype, 4.2.2.2
  INTERVAL YEAR TO MONTH datatype, 4.2.2.1
  ISO 8859 character sets, 2.1.3.1
  ISO locales
    mapping with IANA character sets, 8.6.6
  ISO standard
    date format, 9.3.2
  ISO standard date format, 3.6.1.2, 9.3.2
  ISO week number, 9.3.2
  IW format element, 9.3.2
  IY format element, 9.3.2

## J

  Java
    Unicode data conversion, 7.5.5
  Java strings
    binding and defining in Unicode, 7.5.1
  JDBC drivers
    form of use argument, 7.5.3
  JDBC OCI driver
    and Unicode, 7.1.1
  JDBC programming
    Unicode, 7.5
  JDBC Server Side internal driver
    and Unicode, 7.1.1
  JDBC Server Side thin driver
    and Unicode, 7.1.1
  JDBC thin driver
    and Unicode, 7.1.1

## L

  language
    detecting with Globalization Development Kit, 8.7.6
  language abbreviations, A.1
  Language and Character Set File Scanner, 12.1
  language definition
    customizing, 13.2
    overriding, 3.2.2
  language support, 1.2.1
  languages
    error messages, A.2
  languages and character sets
    supported by LCSSCAN, A.5
  LAST_DAY SQL function, 4.4
  lastrpt parameter
    Database Character Set Scanner, 12.5, 12.5
  LCSCCAN
    error messages, 12.1.5
  LCSSCAN, 12.1
    supported languages and character sets, 12.1.4, A.5
  LCSSCAN command
    BEGIN parameter, 12.1.1
    END parameter, 12.1.1
    examples, 12.1.2
    FILE parameter, 12.1.1
    HELP parameter, 12.1.3
    online help, 12.1.3
    RESULTS parameter, 12.1.1
    syntax, 12.1.1
  length semantics, 2.2, 3.11
  LENGTH SQL functions, 9.2.2, 9.2.2
  LIKE conditions in SQL statements, 9.2.3
  LIKE2 SQL condition, 9.2.3
  LIKE4 SQL condition, 9.2.3
  LIKEC SQL condition, 9.2.3
  linguistic sort definitions
    supported, A.6
  linguistic sorts
    accent-insensitive, 5.5
    BINARY, 5.5.2
    BINARY_AI, linguistic sorts
      BINARY_CI, 5.5.2
    case-insensitive, 5.5
    controlling, 9.2.5.4
    customizing, 13.6
      characters with diacritics, 13.6.1, 13.6.2
    levels, 5.3.3.1
    list of defaults, A.1
    parameters, 3.9
  list parameter, 3.7
  lmsgen utility, 10.9
  loading external BFILE data into LOBs, 9.3.4
  LOBs
    loading external BFILE data, 9.3.4
    storing documents in multiple languages, 6.5.3
  locale, 3.2
    dependencies, 3.2.3
    detection
      Globalization Development Kit, 8.6.3
    of Internet application
      determining, 8.3.1
    variant, 3.2.3
  locale information
    mapping between Oracle and other standards, 10.4
  locale-charset-map, 8.8.1
  locale-determine-rule, 8.8.4
  LocaleMapper class, 8.7.8
  locale-parameter-name, 8.8.5
  LOCALTIMESTAMP SQL function, 4.4
  lossy data
    data dictionary, 12.8
  lxegen utility, 13.3.2

## M

  maxblocks parameter
    Database Character Set Scanner, 12.5
  message-bundles, 8.8.6
  migrating a character set
    CSALTER script, 11.2.2
  migrating character sets in Real Application Clusters, 11.2.2.1
  migration
    CHAR columns to NCHAR columns, 11.3.3
    character sets, 11.1
    to NCHAR datatypes, 11.3
    version 8 NCHAR columns to Oracle9i and later, 11.3.1
  mixed character sets
    causing data loss, 11.1.2.2
  monetary parameters, 3.8
  monolingual Internet application, 8.2.1
  monolingual linguistic sorts
    example, 5.5.3
    supported, A.6
  months
    format element, 3.5.1.2
    language of names, 3.5.1.2
  MONTHS_BETWEEN SQL function, 4.4
  multibyte encoding schemes, 2.1.4.2
    fixed-width, 2.1.4.2
    shift-sensitive variable-width, 2.1.4.2
    variable-width, 2.1.4.2
  multilexers
    creating, 6.5.4.1
  multilingual data
    specifying column lengths, 6.5.1
  multilingual document search
    creating indexes, 6.5.4
  multilingual Internet application, 8.2.2
  multilingual linguistic sorts
    example, 5.5.3
    supported, A.6
  multilingual support
    restricted, 2.6.1
    unrestricted, 2.6.2
  multiple languages
    designing database schemas, 6.5
    storing data, 6.5.2
    storing documents in LOBs, 6.5.3

## N

  N SQL function, 7.2.5
  national character set, 2.3.8, 6.3.2, 7.2.1.1, 7.2.1.2
  NCHAR columns
    migrating from version 8 to Oracle9i and later, 11.3.1
  NCHAR datatype, 7.2.1.1
    creating abstract datatype, 2.3.9
    migrating, 11.3
    migration, 11.3.1
  NCHR SQL function, 7.2.7
  NCLOB datatype, 7.2.1.3
  NEW_TIME SQL function, 4.4
  NEXT_DAY SQL function, 4.4
  NLB data
    transportable, 13.10
  NLB file, 13.1.3.1
  NLB files, 13.1
    generating and installing, 13.7
  NLS Calendar Utility, 13.3.2
  NLS parameters
    default values in SQL functions, 9.1.1
    list, 3.1
    setting, 3.1
    specifying in SQL functions, 9.1.2
    unacceptable in SQL functions, 9.1.3
  NLS Runtime Library, 1.1.1
  NLS_CALENDAR parameter, 3.6.2
  NLS_CHARSET_DECL_LEN SQL function, 9.2.4.3
  NLS_CHARSET_ID SQL function, 9.2.4.2
  NLS_CHARSET_NAME SQL function, 9.2.4.1
  NLS_COMP parameter, 3.9.2, 9.2.5.3
  NLS_CREDIT parameter, 3.8.7
  NLS_CURRENCY parameter, 3.8.2
  NLS_DATABASE_PARAMETERS data dictionary view, 3.3.1
  NLS_DATE_FORMAT initialization parameter, 4.5.1
  NLS_DATE_FORMAT parameter, 3.5.1.1
  NLS_DATE_LANGUAGE parameter, 3.5.1.2
  NLS_DEBIT parameter, 3.8.8
  NLS_DUAL_CURRENCY parameter, 3.8.4
  NLS_INITCAP SQL function, 5.4.11, 9.1
  NLS_INSTANCE_PARAMETERS data dictionary view, 3.3.1
  NLS_ISO_CURRENCY parameter, 3.8.3
  NLS_LANG parameter, 3.2
    choosing a locale, 3.2
    client setting, 3.2.4
    examples, 3.2.1
    OCI client applications, 7.3.3
    specifying, 3.2.1
    UNIX client, 3.2.4
    Windows client, 3.2.4
  NLS_LANGUAGE parameter, 3.4.1
  NLS_LENGTH_SEMANTICS parameter, 2.2
  NLS_LIST_SEPARATOR parameter, 3.10
  NLS_LOWER SQL function, 5.4.11, 5.5, 9.1
  NLS_MONETARY_CHARACTERS parameter, 3.8.6
  NLS_NCHAR_CONV_EXCP parameter, 3.10.1
  NLS_NUMERIC_CHARACTERS parameter, 3.7.2
  NLS_SESSION_PARAMETERS data dictionary view, 3.3.1
  NLS_SORT parameter, 3.9.1, 5.7.2.1
  NLS_TERRITORY parameter, 3.4.2
  NLS_TIMESTAMP_FORMAT initialization parameter, 4.5.1
  NLS_TIMESTAMP_FORMAT parameter
    parameters
      NLS_TIMESTAMP_FORMAT, 3.5.2.1, 3.5.2.2
  NLS_TIMESTAMP_TZ_FORMAT initialization parameter, 4.5.1
  NLS_UPPER SQL function, 5.4.11, 5.5, 9.1
  NLSRTL, 1.1.1
  NLSSORT SQL function, 9.1, 9.2.5
    syntax, 9.2.5.1
  NLT files, 13.1
  numbers, encoding, 2.1.2.3
  numeric formats, 3.7.1
    SQL masks, 9.3.3
  numeric parameters, 3.7
  NUMTODSINTERVAL SQL function, 4.4
  NUMTOYMINTERVAL SQL function, 4.4
  NVARCHAR datatype
    Pro*C/C++, 7.4.3
  NVARCHAR2 datatype, 7.2.1.2

## O

  obsolete locale data, A.9.4
  OCI
    binding and defining CLOB and NCLOB data in OCI, 7.3.7
    binding and defining SQL NCHAR datatypes, 7.3.5
    setting the character set, 10.2
    SQL CHAR datatypes, 7.3.4
  OCI and Unicode, 7.1.1
  OCI character set conversion, 7.3.2.2
    data loss, 7.3.2.1
    performance, 7.3.2.2
  OCI client applications
    using Unicode character sets, 7.3.3
  OCI data conversion
    data expansion, 7.3.2.3
  OCI_ATTR_CHARSET_FORM attribute, 7.3.2.1
  OCI_ATTR_MAXDATA_SIZE attribute, 7.3.2.3
  OCI_UTF16ID character set ID, 7.3.1
  OCIBind() function, 7.3.4
  OCICharSetConversionIsReplacementUsed(), 10.7
  OCICharSetConvert(), 10.7
  OCICharsetToUnicode(), 10.7
  OCIDefine() function, 7.3.4
  OCIEnvNlsCreate(), 7.3.1, 10.2
  OCILobRead() function, 7.3.7
  OCILobWrite() function, 7.3.7
  OCIMessageClose(), 10.8
  OCIMessageGet(), 10.8
  OCIMessageOpen(), 10.8
  OCIMultiByteInSizeToWideChar(), 10.5
  OCIMultiByteStrCaseConversion(), 10.5
  OCIMultiByteStrcat(), 10.5
  OCIMultiByteStrcmp(), 10.5
  OCIMultiByteStrcpy(), 10.5
  OCIMultiByteStrlen(), 10.5
  OCIMultiByteStrncat(), 10.5
  OCIMultiByteStrncmp(), 10.5
  OCIMultiByteStrncpy(), 10.5
  OCIMultiByteStrnDisplayLength(), 10.5
  OCIMultiByteToWideChar(), 10.5
  OCINlsCharSetIdToName(), 10.3
  OCINlsCharSetNameTold(), 10.3
  OCINlsEnvironmentVariableGet(), 10.3
  OCINlsGetInfo(), 10.3, 10.3
  OCINlsNameMap(), 10.4
  OCINlsNumericInfoGet(), 10.3
  OCIUnicodeToCharset(), 10.7
  OCIWideCharDisplayLength(), 10.5
  OCIWideCharInSizeToMultiByte(), 10.5
  OCIWideCharIsAlnum(), 10.6
  OCIWideCharIsAlpha(), 10.6
  OCIWideCharIsCntrl(), 10.6
  OCIWideCharIsDigit(), 10.6
  OCIWideCharIsGraph(), 10.6
  OCIWideCharIsLower(), 10.6
  OCIWideCharIsPrint(), 10.6
  OCIWideCharIsPunct(), 10.6
  OCIWideCharIsSingleByte(), 10.6
  OCIWideCharIsSpace(), 10.6
  OCIWideCharIsUpper(), 10.6, 10.7
  OCIWideCharIsXdigit(), 10.6
  OCIWideCharMultibyteLength(), 10.5
  OCIWideCharStrCaseConversion(), 10.5
  OCIWideCharStrcat(), 10.5
  OCIWideCharStrchr(), 10.5
  OCIWideCharStrcmp(), 10.5
  OCIWideCharStrcpy(), 10.5
  OCIWideCharStrlen(), 10.5
  OCIWideCharStrncat(), 10.5
  OCIWideCharStrncmp(), 10.5
  OCIWideCharStrncpy(), 10.5
  OCIWideCharStrrchr(), 10.5
  OCIWideCharToLower(), 10.5
  OCIWideCharToMultiByte(), 10.5
  OCIWideCharToUpper(), 10.5
  ODBC Unicode applications, 7.6.4
  OLE DB Unicode datatypes, 7.6.5
  online table redefinition
    migrating from CHAR to NCHAR, 11.3.3, 11.3.3.2
  operating system
    character set compatibility with applications, 2.3.2
  ORA_NLS10 environment variable, 1.1.1
  ORA_SDTZ environment variable, 4.5.2, 4.9
  ORA_TZFILE environment variable, 4.5.2
  Oracle Call Interface and Unicode, 7.1.1
  Oracle Data Provide for .NET and Unicode, 7.1.1
  Oracle Language and Character Set Detection Java classes, 8.7.6
  Oracle Locale Builder
    choosing a calendar format, 13.3
    choosing currency formats, 13.3
    choosing date and time formats, 13.3
    displaying code chart, 13.4
    Existing Definitions dialog box, 13.1.3.1
    fonts, 13.1.1.1, 13.1.1.2
    Open File dialog box, 13.1.3.4
    Preview NLT screen, 13.1.3.3
    restrictions on names for locale objects, 13.2
    Session Log dialog box, 13.1.3.2
    starting, 13.1.2
  Oracle ODBC driver and Unicode, 7.1.1
  Oracle OLE DB driver and Unicode, 7.1.1
  Oracle Pro*C/C++ and Unicode, 7.1.1
  oracle.i18n.lcsd package, 8.9.1
  oracle.i18n.net package, 8.9.2
  oracle.i18n.servlet package, 8.9.3
  oracle.i18n.text package, 8.9.4
  oracle.i18n.util package, 8.9.5
  oracle.sql.CHAR class
    character set conversion, 7.5.6.1
    getString() method, 7.5.6.1
    getStringWithReplacement() method, 7.5.6.1
    toString() method, 7.5.6.1
  ORDER BY clause, 9.2.5.4
  OS_TZ local operating system time zone, 4.9
  overriding language and territory definitions, 3.2.2

## P

  page-charset, 8.8.2
  parameters
    BLANK_TRIMMING, 11.1.1.1
    calendar, 3.6
    character set conversion, 3.10
    linguistic sorts, 3.9
    methods of setting, 3.1
    monetary, 3.8
    NLS_CALENDAR, 3.6.2
    NLS_COMP, 3.9.2
    NLS_CREDIT, 3.8.7
    NLS_CURRENCY, 3.8.2
    NLS_DATE_FORMAT, 3.5.1.1
    NLS_DATE_LANGUAGE, 3.5.1.2
    NLS_DEBIT, 3.8.8
    NLS_DUAL_CURRENCY, 3.8.4
    NLS_ISO_CURRENCY, 3.8.3
    NLS_LANG, 3.2
    NLS_LANGUAGE, 3.4.1
    NLS_LIST_SEPARATOR, 3.10
    NLS_MONETARY_CHARACTERS, 3.8.6
    NLS_NCHAR_CONV_EXCP, 3.10.1
    NLS_NUMERIC_CHARACTERS, 3.7.2
    NLS_SORT, 3.9.1
    NLS_TERRITORY, 3.4.2
    numeric, 3.7
    setting, 3.1
    time and date, 3.5
    time zone, 3.5.2.1, 3.5.2.2
  partitioned
    indexes, 9.2.5.3
    tables, 9.2.5.3
  performance
    choosing a database character set, 2.3.4
    during OCI Unicode character set conversion, 7.3.2.2
  phonetic writing systems, encoding, 2.1.2.1
  PL/SQL and SQL and Unicode, 7.1.1
  preserve parameter
    Database Character Set Scanner, 12.5
  primary level sort, 5.3.3.1
  Private Use Area, 13.5.3
  Pro*C/C++
    data conversion, 7.4.1
    NVARCHAR datatype, 7.4.3
    UVARCHAR datatype, 7.4.4
    VARCHAR datatype, 7.4.2
  punctuation, encoding, 2.1.2.3

## Q

  query parameter
    Database Character Set Scanner, 12.5

## R

  Real Application Clusters
    database character set migration, 11.2.2.1
  REGEXP SQL functions, 5.9
  regular expressions
    character class, 5.9.3
    character range, 5.9.1
    collation element delimiter, 5.9.2
    equivalence class, 5.9.4
    examples, 5.9.5
    multilingual environment, 5.9
  replacement characters
    CONVERT SQL function, 9.2.1
  restricted multilingual support, 2.6.1, 2.6.1
  restrictions
    data truncation, 11.1.1.1
    passwords, 11.1.1.1
    space padding during export, 11.1.1.1
    usernames, 11.1.1.1
  reverse secondary sorting, 5.4.7
  ROUND (date) SQL function, 4.4
  RPAD SQL function, 7.2.6

## S

  scan modes
    Database Character Set Scanner, 12.3
    full database scan, 12.3.1
    single table scan, 12.3.3
    user tables scan, 12.3.2
  scan.err file, 12.7
  scan.out file, 12.6.1.3, 12.6.2.3, 12.6.3.3, 12.6.3.6, 12.6.4.3
  scan.txt file, 12.7
  searching multilingual documents, 6.5.4
  searching string, 5.8
  secondary level sort, 5.3.3.2
  session parameters
    ERROR_ON_OVERLAP, 4.5.3
  session time zone, 4.9
  SESSIONTIMEZONE SQL function, 4.4
  setFormOfUse() method, 7.5.3
  shift-sensitive variable-width multibyte encoding schemes, 2.1.4.2
  single-byte encoding schemes, 2.1.4.1
  sorting
    reverse secondary, 5.4.7
    specifying nondefault linguistic sorts, 3.9.1, 3.9.2
  source_char_set parameter, A.4.6
  space padding
    during export, 11.1.1.1
  special combination letters, 5.4.3, 5.4.10
  special letters, 5.4.4, 5.4.9
  special lowercase letters, 5.4.12
  special uppercase letters, 5.4.11
  SQL CHAR datatypes, 2.3
    OCI, 7.3.4
  SQL conditions
    LIKE2, 9.2.3
    LIKE4, 9.2.3
    LIKEC, 9.2.3
  SQL functions
    ADD_MONTHS, 4.4
    CONVERT, 9.2.1
    CURRENT_DATE, 4.4
    CURRENT_TIMESTAMP, 4.4
    datatype conversion, 7.2.5
    DBTIMEZONE, 4.4
    default values for NLS parameters, 9.1.1
    EXTRACT (datetime), 4.4
    FROM_TZ, 4.4
    INSTR, 7.2.6, 9.2.2, 9.2.2
    LAST_DAY, 4.4
    LENGTH, 9.2.2, 9.2.2
    LOCALTIMESTAMP, 4.4
    MONTHS_BETWEEN, 4.4
    N, 7.2.5
    NCHR, 7.2.7
    NEW_TIME, 4.4
    NEXT_DAY, 4.4
    NLS_CHARSET_DECL_LEN, 9.2.4.3
    NLS_CHARSET_ID, 9.2.4.2
    NLS_CHARSET_NAME, 9.2.4.1
    NLS_INITCAP, 5.4.11, 9.1
    NLS_LOWER, 5.4.11, 5.5, 9.1
    NLS_UPPER, 5.4.11, 5.5, 9.1
    NLSSORT, 9.1, 9.2.5
    NUMTODSINTERVAL, 4.4
    NUMTOYMINTERVAL, 4.4
    ROUND (date), 4.4
    RPAD, 7.2.6
    SESSIONTIMEZONE, 4.4
    specifying NLS parameters, 9.1.2
    SUBSTR, 9.2.2, 9.2.2
    SUBSTR2, 9.2.2
    SUBSTR4, 9.2.2
    SUBSTRB, 9.2.2
    SUBSTRC, 9.2.2
    SYS_EXTRACT_UTC, 4.4
    SYSDATE, 4.4
    SYSTIMESTAMP, 4.4
    TO_CHAR, 9.1
    TO_CHAR (datetime), 4.4
    TO_DATE, 7.2.5, 9.1
    TO_DSINTERVAL, 4.4
    TO_NCHAR, 7.2.5
    TO_NUMBER, 9.1
    TO_TIMESTAMP, 4.4
    TO_TIMESTAMP_TZ, 4.4
    TO_YMINTERVAL, 4.4
    TRUNC (date), 4.4
    TZ_OFFSET, 4.4
    unacceptable NLS parameters, 9.1.3
    UNISTR, 7.2.7
  SQL NCHAR datatypes
    binding and defining in OCI, 7.3.5
  SQL statements
    LIKE conditions, 9.2.3
  strict superset, 6.2.2.1
  string comparisons
    WHERE clause, 9.2.5.2
  string literals
    Unicode, 7.2.7
  string manipulation using OCI, 10.5
  strings
    searching, 5.8
  SUBSTR SQL function, 9.2.2
  SUBSTR SQL functions, 9.2.2
    SUBSTR, 9.2.2
    SUBSTR2, 9.2.2
    SUBSTR4, 9.2.2
    SUBSTRB, 9.2.2
    SUBSTRC, 9.2.2
  SUBSTR4 SQL function, 9.2.2
  SUBSTRB SQL function, 9.2.2
  SUBSTRC SQL function, 9.2.2
  superset, strict, 6.2.2.1
  supersets and subsets, A.4.7
  supplementary characters, 5.3.2, 6.2.1
    linguistic sort support, A.6
  supported datatypes, 2.3.9
  supported territories, A.3
  suppress parameter
    Database Character Set Scanner, 12.5
  surrogate pairs, 6.2.1
  syllabary, 2.1.2.2
  symbols, encoding, 2.1.2.3
  SYS_EXTRACT_UTC SQL function, 4.4
  SYSDATE SQL function, 4.4
    effect of session time zone, 4.9
  sys.sys_tzuv2_temptab table, 4.7
  SYSTIMESTAMP SQL function, 4.4

## T

  table parameter
    Database Character Set Scanner, 12.5
  tables
    partitioned, 9.2.5.3
  territory
    dependencies, 3.2.3
  territory definition, 3.4.2
    customizing, 13.3
    overriding, 3.2.2
  territory support, 1.2.2, A.3
  territory variant, 3.2.3
  tertiary level sort, 5.3.3.3
  Thai and Laotian character rearrangement, 5.4.8
  tilde, 7.5.7.1
  time and date parameters, 3.5
  time zone
    abbreviations, 4.6
    data source, 4.6
    database, 4.8
    effect on SYSDATE SQL function, 4.9
    environment variables, 4.5.2
    names, 4.6
    parameters, 3.5.2.1, 3.5.2.2
    session, 4.9
  time zone file
    choosing, 4.6
    default, 4.6
  time zones
    converting, 4.10
    customizing, 13.3.1
    upgrading definitions, 4.7
  TIMESTAMP datatype, 4.2.1.2
    when to use, 4.2.1.6
  TIMESTAMP datatypes
    choosing, 4.2.1.6
  timestamp format, 3.5.2.1
  TIMESTAMP WITH LOCAL TIME ZONE datatype, 4.2.1.4
    when to use, 4.2.1.6
  TIMESTAMP WITH TIME ZONE datatype, 4.2.1.3
    when to use, 4.2.1.6
  timezlrg.dat file, 13.3.1
  timezone.dat file, 13.3.1
  TO_CHAR (datetime) SQL function, 4.4
  TO_CHAR SQL function, 9.1
    default date format, 3.5.1.1, 4.5.1
    format masks, 9.3.1
    group separator, 3.7.2
    language for dates, 3.5.1.2
    spelling of days and months, 3.5.1.2
  TO_DATE SQL function, 7.2.5, 9.1
    default date format, 3.5.1.1, 4.5.1
    format masks, 9.3.1
    language for dates, 3.5.1.2
    spelling of days and months, 3.5.1.2
  TO_DSINTERVAL SQL function, 4.4
  TO_NCHAR SQL function, 7.2.5
  TO_NUMBER SQL function, 9.1
    format masks, 9.3.1
  TO_TIMESTAMP SQL function, 4.4
  TO_TIMESTAMP_TZ SQL function, 4.4
  TO_YMINTERVAL SQL function, 4.4
  tochar parameter
    Database Character Set Scanner, 12.5
  toString() method, 7.5.6.1
  transportable NLB data, 13.10
  TRUNC (date) SQL function, 4.4
  TZ_OFFSET SQL function, 4.4
  TZABBREV, 4.6
  TZNAME, 4.6

## U

  UCS-2 encoding, 6.2.2.2
  Unicode, 6.1
    binding and defining Java strings, 7.5.1
    character code assignments, B.1
    character set conversion between OCI client and database server, 7.3.2
    code ranges for UTF-16 characters, B.1
    code ranges for UTF-8 characters, B.1
    data conversion in Java, 7.5.5
    encoding, 6.2.2
    fonts, 13.1.1
    JDBC OCI driver, 7.1.1
    JDBC programming, 7.5
    JDBC Server Side internal driver, 7.1.1
    JDBC Server Side thin driver, 7.1.1
    JDBC thin driver, 7.1.1
    mode, 7.3.1
    ODBC and OLE DB programming, 7.6
    Oracle Call Interface, 7.1.1
    Oracle Data Provide for .NET, 7.1.1
    Oracle ODBC driver, 7.1.1
    Oracle OLE DB driver, 7.1.1
    Oracle Pro*C/C++, 7.1.1
    Oracle support, 6.2.3
    parsing an XML stream with Java, 7.7.3
    PL/SQL and SQL, 7.1.1
    Private Use Area, 13.5.3
    programming, 7.1
    reading an XML file with Java, 7.7.2
    string literals, 7.2.7
    UCS-2 encoding, 6.2.2.2
    UTF-16 encoding, 6.2.2.3
    UTF-8 encoding, 6.2.2.1
    writing an XML file with Java, 7.7.1
    XML programming, 7.7
  Unicode database, 6.3.1
    case study, 6.4
    choosing a character set, 6.3.4
    using with Unicode datatypes (case study), 6.4
    when to use, 6.3.3.1
  Unicode datatypes, 6.3.2
    case study, 6.4
    choosing a national character set, 6.3.4
    using with a Unicode database (case study), 6.4
    when to use, 6.3.3.2
  UNISTR SQL function, 7.2.7
  unrestricted multilingual support, 2.6.2
  url-rewrite-rule, 8.8.7
  US7ASCII
    supersets, A.4.7
  user parameter
    Database Character Set Scanner, 12.5
  user-defined characters, 13.5.1
    adding to a character set definition, 13.5.6
    cross-references between character sets, 13.5.4
  userid parameter
    Database Character Set Scanner, 12.5
  UTC, 4.2.1.3, 4.2.1.4
  UTF-16 encoding, 6.2.2.3, B.2
  UTF8 character set, 6.3.1, A.4.5
  UTF-8 encoding, 6.2.2.1, B.3
  UTFE character set, 6.2.3, 6.3.1, A.4.5
  UTL_FILE package, using with NCHAR, 7.2.9
  UTL_I18N PL/SQL package, 8.10
  UTL_LMS PL/SQL package, 8.10
  utltzuv2.sql script, 4.7
  UVARCHAR datatype
    Pro*C/C++, 7.4.4

## V

  V$NLS_PARAMETERS dynamic performance view, 3.3.2
  V$NLS_VALID_VALUES dynamic performance view, 3.3.2
  VARCHAR datatype
    Pro*C/C++, 7.4.2
  variable-width multibyte encoding schemes, 2.1.4.2
  version 8 NCHAR columns
    migrating to Oracle9i and later, 11.3.1

## W

  wave dash, 7.5.7.1
  WHERE clause
    string comparisons, 9.2.5.2

## X

  XML
    parsing in Unicode with Java, 7.7.3
    reading in Unicode with Java, 7.7.2
    writing in Unicode with Java, 7.7.1
  XML programming
    Unicode, 7.7